-
Re: Auto direct risk from master register to project risk
Hey @Ide AirTrunk Nice job on the flow. One step I sometimes needed was an Array Length step after a Search step, where I could check if the returned array had a length greater than zero - a similar …1 · -
Re: Automations "Equals" vs "Contains"
Hey @Mark K The CONTAINS function works best for text strings, not numbers. You can switch to the FIND function to mitigate. Remember that the FIND function returns numbers, not T/F so you need FIND(…1 · -
Re: I want to check a box if the outage was identified on a workday between 8:00-16:00
Hey @Amy A Try this =IF(AND(AND([Day of Week]@row > 1, [Day of Week]@row < 7), AND(TIME(Time@row, 1) >= TIME(8, 0, 0), TIME(Time@row, 1) <= TIME(16, 0, 0))), 1) Will this work for you? Ke…1 · -
Re: Formulas to Calculate Dates/Duration
Hey @rmc0030 To find the Stage 1 duration you may need to add the system column Created (date) to your sheet, if you don't already have it. This will allow you to calculate from initiation to Stage 1…1 · -
Re: IF(CONTAINS()) function returns an "Error Unknown function: 'CONTAINS'."
Hey @BTR214 The IF statement cannot answer your question as you have asked if "2100" is contained in the entire column. The answer is both true and false. Try this (like @NickStaffordPM , I…1 ·